SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003115s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 194063 LIMIT 1 [ RunTime:0.001673s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 194063 [ RunTime:0.009958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (583302,128116,727173,996534,875232,218172,1030546,1007221,6120,462010,440501,291999,776936,663293,664568,883317,593104,364630,158324,525042,1010197,968502,976123,103970,492969,334744,282873,966844,177019,352949,669165,608952,285608,353842,90067,662637,443086,462543,968057,744869,141786,552918,116299,215345,142164,200490,211371,1810,455790,967927,787472,351153,863415,565015,573505,781929,121641,309706,419655,128843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006243s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 194063 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 194063 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004833s ]