SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565825 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565825 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470067,829582,684437,75455,405529,291133,606597,744987,699984,805135,137652,641063,563890,411549,513843,244108,854761,273495,249374,127180,1035210,804183,915431,599548,861027,54713,782526,280975,203185,976430,285376,957643,134061,135820,26760,295260,315966,548657,441818,173176,781431,874430,562817,1043797,109379,979529,749550,351589,373274,356914,154747,771744,628989,714565,52878,581742,842013,459208,321886,225771) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000994s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000506s ]