SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001314s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480433 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480433 [ RunTime:0.001579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196013,625452,679651,978707,920663,508954,135569,34253,692140,870528,837722,153859,1041617,954396,559837,678464,910365,464851,826589,197517,842353,395590,720633,829656,387745,146456,810783,834927,675413,759641,467800,400358,505448,331654,529605,6604,88734,948719,746601,793196,416957,208732,469892,409082,889462,600811,149559,1018779,124303,979563,215131,929689,406164,230796,507299,45591,175981,696252,688528,222892) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480433 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480433 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]