SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34437 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34437 [ RunTime:0.001629s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (259702,315704,242085,56888,942923,695587,19269,996842,654305,524191,248595,688542,553766,1014008,103657,877892,171777,340574,317297,968974,434531,364678,301322,812428,827744,51626,535475,518617,461257,312653,250585,681180,865027,295011,421218,639681,51291,637732,855949,166443,1019253,799027,7841,197138,512059,156247,474798,977161,615060,3076,945362,624084,1002742,894745,698224,413585,248493,744583,835266,564312) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34437 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34437 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]