SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001086s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 921083 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 921083 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503087,580216,491259,819921,172548,307426,154989,29657,111096,210287,125034,988155,1007454,90473,854459,1011366,1045483,150590,269063,425713,546634,156983,369766,686252,663281,731570,904337,867613,943321,179387,388965,651867,990472,493236,524145,192143,664895,369305,754483,1043383,499290,318403,243771,1038932,321365,448870,1040745,569746,926998,416192,517934,494279,293953,982084,392863,15678,249989,790439,166696,283241) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000995s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 921083 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 921083 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]