SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002894s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 400200 LIMIT 1 [ RunTime:0.002505s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 400200 [ RunTime:0.002138s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1044906,391233,803491,916581,343418,244689,928826,524442,519268,859435,480806,358470,603270,961873,390950,843834,995101,32779,755562,279616,440547,252761,473691,934935,66136,963924,346479,866860,105864,80363,863080,59800,78223,101326,914171,998470,771299,910424,94837,814202,175787,594345,899951,996017,227591,635105,440594,104829,485909,204999,408572,769929,986379,486112,714310,810683,618354,448170,631151,169053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 400200 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 400200 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000608s ]