SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201276 LIMIT 1 [ RunTime:0.000351s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201276 [ RunTime:0.001797s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712292,383175,509925,232074,379397,627560,689030,479030,703949,490170,918921,157599,200308,348541,983823,845302,782769,33558,817325,72950,882059,397194,615442,92596,307950,624014,359799,124920,219764,263909,787298,684827,548623,733354,213923,77018,650594,391390,113788,955667,928660,238281,580184,168118,144679,291782,721314,193477,743793,1018216,395992,967094,641007,159116,942683,322202,403307,872985,266747,937511) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201276 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000450s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201276 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000457s ]