SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 468324 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468324 [ RunTime:0.002311s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (941244,602187,618412,1011440,405310,220146,440461,664082,67887,694465,903455,15001,358014,685068,376918,331967,37728,80593,797657,462567,100552,875559,89421,205275,498618,1046129,28167,106729,667689,545266,402069,3920,1001818,14228,647963,483501,337691,662954,189279,118395,553972,628422,388390,639718,516969,1035076,248038,730799,770891,3291,639313,207677,656422,411500,170541,580459,646119,253086,348455,229785) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468324 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468324 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]