SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001686s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 107527 LIMIT 1 [ RunTime:0.002256s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 107527 [ RunTime:0.004520s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (918177,366161,628286,897996,501685,501292,375386,845773,17653,867293,1019594,500047,559332,721897,800968,985428,254959,584973,353287,793897,841599,327586,145558,412379,669652,742,937722,762692,88977,647592,264836,550066,134574,1031260,839774,509641,741243,941438,879928,644107,979611,360005,808670,853174,693373,415256,270328,824766,642269,257647,155423,562725,840223,347476,837817,26715,974345,474213,1040458,412926) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005974s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 107527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000708s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 107527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001737s ]