SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421097 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421097 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (417052,603474,150473,1027635,699559,842317,729694,737036,373540,750018,298373,468870,191797,966744,1010020,871978,103992,587459,619734,480857,669114,172339,500408,123115,476794,110529,191294,495481,748322,870158,721092,529508,981498,540739,875283,49739,761789,970110,1048011,106393,275217,116607,327667,403070,595244,600176,636793,787467,260471,111535,179547,894157,762931,494518,969857,33855,143322,127966,20204,416816) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000669s ]