SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 494611 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 494611 [ RunTime:0.002097s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150172,735807,45888,393908,332773,171000,860350,875785,502315,9473,612521,773081,21338,798282,251342,101564,205445,212784,590051,859860,482715,153467,839009,980301,438605,225789,421060,809491,634892,100694,638142,516833,758760,849896,925434,798591,535075,442410,664202,649955,541857,690719,192131,349195,145923,1031658,302375,1014854,1014888,868112,404645,647566,644357,751939,167547,924110,366943,442518,296183,279288) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001949s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 494611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 494611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]