SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542718 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542718 [ RunTime:0.001865s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (690510,180679,636508,815937,656115,325675,167544,917605,703289,736427,400239,860022,1009670,931223,143058,1029874,375662,843008,815706,398290,955542,402639,33420,275624,577896,997172,392338,21091,1047412,626426,303595,920971,576622,650685,154229,287820,701853,1022262,767341,710860,160131,49848,474370,494396,731431,599740,114492,38835,799268,661000,554620,159418,499762,208297,339045,160649,640779,378929,35767,683570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542718 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542718 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]