SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001229s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401801 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401801 [ RunTime:0.001907s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (981167,519540,976690,121693,517955,525990,947892,495144,863104,227803,170419,949660,950687,269503,430810,895452,895270,668482,1012292,1008529,793385,430387,199640,70510,64307,802380,673679,328720,108974,98004,880100,212790,19627,286950,722757,663105,892773,138927,2434,1010947,247193,919780,289174,181304,46152,520468,566808,884592,17134,708330,922829,512291,762413,569629,355669,670608,216549,896348,947283,1042433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001827s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000839s ]