SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001236s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 588058 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 588058 [ RunTime:0.001822s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (746611,920294,393557,777194,612698,300430,697566,44532,901566,68587,1030864,601986,92172,387281,738433,526315,69136,323124,103857,610601,570530,100799,260892,637797,410290,766544,914541,718043,29778,139186,212929,582693,610927,308034,547589,587824,827150,56117,721197,771837,202620,410786,718203,785788,632012,608472,454425,894533,284050,455625,624899,146775,628346,412563,206084,70547,95367,288411,991517,1001309) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 588058 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 588058 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000905s ]