SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409111 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409111 [ RunTime:0.001370s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616065,273920,112351,76418,383298,670130,675976,579722,133938,685588,842362,848827,352154,899061,251067,908784,579403,645047,347093,605181,891061,606476,19489,818001,1001119,850344,498065,1024369,303442,20211,850298,529360,758682,548119,399089,37166,761626,331110,528092,68535,195614,578968,510428,184636,875137,813240,1030757,412998,425605,410778,1018475,241319,851027,540509,370799,253174,688803,204338,213685,252674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000337s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]