SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 610812 LIMIT 1 [ RunTime:0.001405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 610812 [ RunTime:0.004980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495682,850862,952830,1002919,347837,755195,298537,452616,215620,365701,437863,626423,936611,412354,260609,937845,31315,165577,887028,511002,825705,994146,178760,815909,358547,739499,141885,1035422,412984,957998,544214,190017,501102,585684,564320,66778,584156,285954,871891,509793,283784,796184,134393,817289,430408,909678,543123,626987,77841,567157,770690,622802,295390,269268,63598,287930,499311,370131,1014516,971620) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 610812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 610812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000991s ]