SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001793s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 31668 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 31668 [ RunTime:0.001916s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (706172,676496,232766,309697,705482,15336,174187,94966,498314,643603,463425,925657,369342,87055,405188,306024,1028529,616613,954559,446787,843754,201630,698607,85501,850646,19237,921313,390602,83471,769522,4406,559972,1026778,771881,262404,822467,852963,400815,7355,786205,565625,773122,141288,119435,45776,1006863,186259,512265,781260,367622,553094,968113,12407,889741,469657,699555,134597,844591,755489,674941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001109s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 31668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 31668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000419s ]