SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005067s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 244004 LIMIT 1 [ RunTime:0.001795s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 244004 [ RunTime:0.003208s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (510262,645438,450785,113471,185777,551994,687990,312003,337578,848424,632062,240825,534986,1002052,479408,273239,146293,798497,433301,1008546,662681,460595,410643,468713,397729,776325,670027,320107,355004,226091,773804,570198,317471,619093,855651,76918,774927,5261,933937,954659,287780,553208,783989,398915,973752,637540,603226,702500,243930,774568,267592,449222,283367,965251,833899,354999,59259,590052,426954,1033774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 244004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003303s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 244004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002387s ]