SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 382711 LIMIT 1 [ RunTime:0.003096s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 382711 [ RunTime:0.001201s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741377,111473,38781,885185,1033448,923184,729002,837156,799921,628841,35506,944564,482609,58523,635838,193784,753824,699679,216711,476611,853821,503723,935068,300098,1028723,975954,51542,229633,434370,523736,153362,263255,805902,330399,182799,343882,860109,772726,14653,646495,1019018,34698,1044030,91840,451566,450907,336774,942919,734482,990091,390092,148916,983115,932089,36411,697379,543537,59955,321141,18315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 382711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003744s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 382711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002688s ]