SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50135 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50135 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634156,96540,224195,837789,612597,687040,926482,784915,293203,861213,736121,453297,326387,395998,985372,51114,550587,865890,11361,70038,1029786,2036,703738,299150,809525,457633,718235,250864,443235,633165,327697,547479,417984,187420,320866,969166,134929,798659,624581,120754,700681,764824,115123,565429,250551,766125,41434,761600,771065,407837,376630,22233,334242,1046836,97789,43093,827445,749585,550372,435177) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50135 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50135 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]