SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5060 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5060 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (590246,572187,881342,828305,1000465,78827,656425,1032663,968366,746289,922567,554733,942343,831202,107474,777213,50974,385942,843652,699965,482579,598151,797416,935009,471937,823685,1014121,612783,105484,784149,843923,415332,873503,11514,434791,226834,942538,797998,984427,219905,112778,524497,230613,732109,953991,926244,382052,411416,218907,798702,543819,135098,293866,244785,557358,393155,107892,331888,294570,295772) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5060 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5060 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000590s ]