SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002918s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 535922 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 535922 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (93845,859335,969266,573656,51366,453048,772673,799745,210856,742926,681673,134213,561841,193039,674873,56266,659853,67715,799987,423867,432855,588987,714960,371773,735289,1018117,775288,294651,974600,49103,621902,680193,493017,973697,1017050,730536,111735,326091,4461,299654,1025887,856713,367002,792093,154203,409703,426366,232676,1030032,589596,389230,441875,663534,455531,649115,1027026,1022715,279851,1020999,815632) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 535922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 535922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]