SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419571 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419571 [ RunTime:0.001606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (219704,85828,314303,346010,614548,669322,451395,846045,55585,753248,124714,931460,174448,450467,138863,461083,500860,640223,298065,519843,952536,564217,251569,642636,1030921,322198,411800,73708,197756,129970,491474,518045,753282,611700,599544,248292,1024490,721593,283846,913449,255172,578022,237405,966905,929683,579428,85566,730631,440063,32370,361471,1027298,702438,658503,944067,109304,161687,756677,119856,974714) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000484s ]