SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548748 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548748 [ RunTime:0.002648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (740516,455311,640761,136462,686451,619074,363219,374224,874977,148430,379924,67873,834400,524654,414875,998206,133316,759890,705686,50189,901748,233607,352918,56721,730309,1015243,701295,137307,881411,490682,810615,953600,863540,18104,379381,934790,930346,683138,741613,973829,681157,703559,385263,788729,1801,513623,724975,737512,863163,189883,379024,261043,179261,142269,275728,366103,218945,424643,172000,141033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548748 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548748 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]