SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 434978 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 434978 [ RunTime:0.003200s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427297,592709,245671,630787,93153,325153,428472,704296,1044951,494016,548995,321645,693301,17,275319,644451,682588,124001,323024,755877,52943,892483,593153,595949,289820,763570,319054,10922,883485,179059,738592,755579,324921,649825,989240,279654,101877,520272,249259,677089,174463,183848,434222,202538,773089,862600,648098,1037750,854829,927856,596698,137822,372489,834698,1009169,161416,291408,708565,690798,554731) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 434978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 434978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000629s ]