SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 684196 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 684196 [ RunTime:0.002339s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022761,482233,123164,624964,927465,335080,936647,655169,480232,403169,704448,411518,133869,711056,264066,926415,737726,244706,698411,216748,832178,605507,197509,521318,231371,581914,4722,842515,373072,319119,785082,354467,825127,344235,524533,1040536,634589,680518,876621,835612,737756,731387,552836,867313,970483,639256,594515,968682,321729,965976,714167,826087,450145,332243,539002,657939,137733,528915,633779,853404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001173s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 684196 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 684196 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]