SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540691 LIMIT 1 [ RunTime:0.005179s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540691 [ RunTime:0.007533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (110516,608193,332889,861021,977051,149556,346721,931552,163619,87891,715413,157101,629861,491468,421916,315604,14300,448955,277416,159588,463313,75148,421976,712334,567244,216790,884044,147578,890369,121287,752784,48329,543941,291139,1020072,908771,828979,888746,377311,965792,1037684,351691,432962,946428,229300,122273,1013410,229167,1021453,367438,512174,107097,227878,726992,363836,1047948,270937,337824,365038,136733) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.005099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000783s ]