SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 429999 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 429999 [ RunTime:0.001620s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (264936,288984,79474,304317,102536,345869,311489,642108,961011,809451,836014,199248,561728,257423,610107,180649,413746,984197,584120,633029,446188,331069,607347,38181,472992,1020040,403549,379936,711861,987357,140792,906230,646063,98271,626639,670555,260038,104012,1016758,838580,340505,269281,969369,1016368,473402,450536,679621,641443,164677,864819,112991,122875,840229,435634,468433,532367,431567,974779,664213,741526) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 429999 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 429999 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]