SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508584 LIMIT 1 [ RunTime:0.002463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508584 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (402283,493367,360026,412512,487696,521535,335684,535069,224774,467056,385463,78933,571350,215526,56820,33724,193980,695138,913074,698070,718954,266398,19364,456134,685949,774759,122004,147478,131070,886661,576626,218495,596379,755519,646012,399726,44316,1028231,621099,886561,134072,850403,196900,870884,41669,165725,858536,859858,149131,729884,675265,812150,100429,133839,9364,2504,790463,689001,752066,948459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]