SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520620 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520620 [ RunTime:0.002408s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (675666,289827,951788,565920,674685,330554,190991,637082,927098,403107,539153,280976,381193,266612,258035,868626,823282,827931,1045251,439296,281826,558892,1017501,701192,607889,426629,960043,187900,494555,321104,979365,351068,631018,1004929,1024740,682448,724950,932982,855877,154012,917002,637021,976986,972599,613713,211102,853099,497574,114718,598402,21276,748411,352845,574359,68725,343381,336781,820587,574258,153810) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001010s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520620 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520620 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]