SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001315s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 882016 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 882016 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (416246,120718,276782,704962,333521,977382,906521,55545,66947,829513,867027,479635,636949,81151,699292,675969,733083,291757,344464,1018200,502412,721255,44597,868011,376029,747251,963372,331804,924495,235049,405324,144002,354352,214127,895710,898738,428645,502591,257545,619870,524868,536602,882457,120542,170461,519078,118253,337241,987404,1018087,484493,571264,769889,40934,375144,30526,104714,94895,279787,206576) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 882016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000568s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 882016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]