SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459510 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459510 [ RunTime:0.001804s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587486,920010,1047364,774532,1047554,653029,210715,1020323,959282,518435,601771,622458,147051,249500,781882,49674,447615,57431,268640,464258,36141,460350,446037,883904,489176,120466,316694,294594,806230,617686,148062,741474,123336,499668,900783,169347,60327,1033637,373316,621169,419869,1034784,48105,373634,633453,265066,902058,172357,992182,638997,986395,120451,615823,714015,980636,338181,496641,753216,724851,16617) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001052s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459510 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000399s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459510 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]