SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001303s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429120 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429120 [ RunTime:0.001756s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108484,219927,496914,804495,769200,278071,894223,498470,110901,499837,724752,657210,194203,608802,594759,799599,806485,661629,66542,86741,714377,931799,703085,459916,328952,775323,603562,87042,567705,989598,270989,282073,762222,876897,730784,331488,890618,438367,901802,417169,128152,248611,682096,38987,63646,147508,330122,258652,855172,696919,11574,751141,422218,252443,1026783,487799,260410,363802,700215,84512) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005022s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001246s ]