SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 265883 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 265883 [ RunTime:0.002294s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174660,97805,261181,356865,133418,583514,103505,960498,109363,794443,928768,809687,581492,760134,453594,1037776,923901,1031842,939105,982496,298198,11194,70357,93656,720524,546480,94076,409997,994142,603881,630609,84466,868810,520948,438288,93041,344760,670054,608035,634003,801223,924969,396332,667449,721239,67974,900399,527756,641172,406132,339795,518866,8041,401681,401608,954417,964834,421959,666640,525805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 265883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 265883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002287s ]