SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 426171 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 426171 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (388469,384221,396885,78693,391711,618959,999370,771925,811747,748129,105418,40752,256421,526364,528494,875738,695197,871255,825818,250780,460517,1044279,330376,23112,573546,825670,863018,878793,555759,1019649,1033080,954750,274899,55568,557345,1047917,977303,134183,759548,8299,356473,711346,362509,964781,611114,365297,1041433,803692,808682,184030,879379,1010468,50840,569456,295534,944696,808064,152361,483833,711564) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 426171 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 426171 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000630s ]