SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 270918 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 270918 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (512922,46195,125511,539064,211676,467201,424988,853064,428528,541263,788463,819029,911063,784963,757191,99735,1024344,1045854,529559,572863,572772,133544,911106,144014,1012289,635673,39857,1010810,587192,365391,571415,762104,731445,387756,837493,479212,1045692,961681,15248,346636,769430,304601,198197,504128,930138,220275,188306,536540,982618,803642,211425,377492,701029,781560,393260,122375,815039,762489,454289,204999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000968s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 270918 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000542s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 270918 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]