SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 926413 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 926413 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (198984,985970,466087,950439,859044,450866,398393,241957,351507,616952,827789,562676,1011307,371893,364868,293683,110388,256565,725434,88046,664353,1016131,1030079,673354,454158,515577,279784,110198,942539,24758,930288,471500,255745,664659,858663,607345,627976,105522,5324,734946,452937,653257,781546,789470,851290,714053,434395,214537,251182,673297,755335,736341,1011052,901205,181220,1046385,705933,327669,740747,701575) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 926413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 926413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001141s ]