SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 456027 LIMIT 1 [ RunTime:0.001964s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 456027 [ RunTime:0.004529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (523641,796777,1027208,806695,505617,360236,996741,965358,748404,13073,365921,441114,427488,981516,903302,779877,127698,286779,674326,616217,671821,311852,234313,758911,1013184,403453,534562,345137,388168,1029892,271299,470534,261086,441026,974493,1032718,333250,627290,783039,821952,737549,80541,83989,532485,438492,1030849,530356,461371,653598,975602,1004384,346076,310440,349298,408497,13737,212562,340004,142813,328071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001136s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 456027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 456027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]