SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001453s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504959 LIMIT 1 [ RunTime:0.000626s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504959 [ RunTime:0.003929s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (24112,474572,421977,568812,757242,908107,151500,48437,955766,59633,261588,165507,49261,180104,853460,881279,664762,223394,457371,601418,794338,516392,827183,263766,531414,458411,503650,18925,646557,578171,975040,382201,356394,940288,427739,685068,128263,157459,957743,565231,197865,355955,321363,966083,170090,309689,600243,319204,456376,40853,266685,624097,945964,106560,993991,252716,755138,653465,674819,698986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504959 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504959 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001919s ]