SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 464897 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 464897 [ RunTime:0.002575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (732819,311570,34912,801655,1034868,184838,636184,939827,650579,885073,119461,600688,690036,483438,703184,959845,72855,275770,231740,532577,982381,232644,483604,786746,753101,45368,357256,587247,969224,705902,586396,246060,734619,924913,631528,149685,889057,821815,588126,6002,440764,237375,149415,749554,72348,729886,373393,851445,202005,860634,735066,127414,778552,921540,991840,615290,129542,779291,889093,16447) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 464897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 464897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]