SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001417s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001794 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001794 [ RunTime:0.002100s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350489,508510,867495,839866,789840,157184,754111,128608,708247,472385,778674,805534,600605,606607,722991,768260,197723,679000,315034,667021,449107,410196,523041,272531,59929,969926,320036,527780,698925,869025,39836,246872,550192,96792,241423,208647,701213,393319,909003,373280,570869,823380,801248,6533,678366,588715,1047090,134871,609773,232803,359776,257130,937317,716012,635992,208841,857046,741968,623774,637600) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000546s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001665s ]