SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501107 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501107 [ RunTime:0.003170s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (355186,2804,726845,119314,579613,762989,376394,195039,53970,968347,772324,255671,649905,566625,469051,208605,56330,548331,787520,381474,644908,419219,850172,606644,592939,866431,653451,613325,566956,260114,289803,34172,775845,374878,1013094,474234,563171,196008,355281,435226,302605,537521,150196,752402,895723,49630,889324,690312,38721,863747,706241,895158,739019,965270,804935,289946,599156,43350,997196,615525) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]