SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001567s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 177203 LIMIT 1 [ RunTime:0.000382s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 177203 [ RunTime:0.002444s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128062,1033459,74703,910263,501540,817271,142157,941651,520187,932658,435678,346966,129110,686907,952000,534776,70513,830384,199510,548888,32410,175512,852037,709600,660678,20097,860810,270226,25706,689738,881296,397644,388986,531760,220671,39493,722264,596923,374767,644775,698389,317549,427715,947456,178340,457198,581800,218959,224664,571549,743894,57907,359030,856145,502451,19897,47609,874986,334222,614108) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001011s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 177203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000580s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 177203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000655s ]