SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193443 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193443 [ RunTime:0.005065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (288186,946920,983820,61070,914707,236552,884690,358321,662809,703632,730198,155153,865220,70837,106716,637276,871557,398680,925926,832812,602266,289422,974073,54978,271668,99821,160556,138913,587545,691312,590052,245186,571609,177450,924751,968765,419994,324025,857170,50168,860163,648038,465895,106447,893427,171228,374997,237034,647939,373168,715225,4490,560114,204030,744897,1045824,686873,175192,388008,93475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000450s ]