SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 780416 LIMIT 1 [ RunTime:0.001369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 780416 [ RunTime:0.001440s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (559819,443938,297034,717278,616839,794903,38714,161230,406445,989400,370290,978937,3759,742017,10297,886847,193957,365168,495331,400932,837053,530795,866899,640123,22900,118578,299865,35400,1010852,990179,241636,322818,310289,354714,422982,90763,461098,271095,578894,80175,521804,431073,332838,831547,531379,925925,816647,10269,113273,876120,483348,424503,678029,809495,722186,457177,253305,90172,165536,1027889) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 780416 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 780416 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001542s ]