SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421300 LIMIT 1 [ RunTime:0.000470s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421300 [ RunTime:0.003081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219460,766899,646040,982689,418389,904376,139970,690076,201428,122869,687996,142913,797098,398864,738909,961281,620694,703780,827710,722007,569791,1031111,1038019,139132,1028972,187408,764232,460359,547758,310643,688031,891142,610747,773482,940979,569141,114723,996802,509521,232013,600468,674576,827324,935079,242418,364240,775081,576092,796421,919153,97388,850444,584774,703117,946015,948259,991781,753085,580177,164343) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]