SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561071 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561071 [ RunTime:0.004170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69669,613846,436419,181191,13936,92811,591023,218071,324465,83574,31422,402860,1039267,254540,745694,623229,7122,281289,775724,795782,410925,273572,640595,913306,424862,877400,496252,496179,968489,994514,499949,357516,79069,452133,189131,252609,1033997,801637,588890,517510,772817,1002432,426991,211038,563775,569753,332032,486604,510630,600515,918127,624737,853250,227418,961402,428429,1041854,397462,824038,139975) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]