SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508100 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508100 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123640,681848,63230,427774,749195,650057,173890,575202,212884,214203,685698,108078,416031,1001902,178599,879842,119644,101410,39927,585576,774316,994878,305208,740528,1039483,487586,476043,812523,40226,180005,969095,705120,797149,1038216,569229,856173,757446,478172,1035271,426617,599490,889137,368793,538021,797664,502068,311634,274000,105004,823617,371674,707125,540413,498498,61751,274785,484329,712567,723739,916016) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000438s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]