SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 67985 LIMIT 1 [ RunTime:0.002713s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 67985 [ RunTime:0.003887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200311,159983,873497,235812,927313,366017,5937,854320,729785,445545,10271,899810,1031903,445409,289525,273814,95903,989511,901208,370711,332770,307541,423643,290333,249222,509478,526551,43793,677276,199377,282847,383639,1022851,197073,446444,680058,771827,179439,618387,61979,156521,570198,1022622,439419,34733,260132,373425,382147,647711,317321,91875,2538,180400,342189,928280,687699,116842,884524,866641,731495) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 67985 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 67985 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001115s ]