SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543922 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543922 [ RunTime:0.001520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (63445,265735,751097,445183,910234,375868,246651,74919,651664,212783,464418,998505,855549,130415,403301,514888,43025,735808,873824,1037522,778464,152581,295444,357670,356360,1046413,296436,359924,1019463,579704,636814,848149,632541,875604,455500,819536,119182,153077,1758,89800,777102,790255,155713,89781,1041101,373182,1029379,92879,314897,189877,620130,426494,720090,776376,334506,445745,96479,586825,20331,344609) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543922 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543922 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000708s ]