SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 804016 LIMIT 1 [ RunTime:0.000763s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804016 [ RunTime:0.004055s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (742454,335528,832801,486189,69902,825547,197023,637741,928113,229419,316052,940614,545959,216998,994158,405693,294805,724347,415977,144593,38571,9392,318924,660977,826883,767759,637468,73567,910539,809417,282659,251402,940703,102300,162973,437599,961549,894609,334130,454616,660578,1010768,791240,808527,895590,727769,9531,1000189,932239,383414,1025680,366462,257183,978209,143897,981845,937829,140153,356963,376346) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804016 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804016 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]