SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 117213 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 117213 [ RunTime:0.002943s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656657,1031433,512170,427240,411810,821626,171032,828872,936010,921952,642201,373832,376375,778025,240133,114922,204202,913677,290004,509700,197893,465589,681018,123580,271804,1022103,522880,325767,12754,892663,131653,664126,628114,138530,786825,611453,545649,690276,491416,366715,589369,13090,192739,1030953,459521,496488,669177,491274,611509,1014967,45301,979978,785415,881448,754499,763866,443697,531254,296021,613629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001972s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 117213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 117213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]