SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406022 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406022 [ RunTime:0.003960s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (457232,891658,472140,262898,442182,567158,585051,647538,978155,219286,1043627,322411,378351,58633,122786,590107,47681,222901,770513,519710,484608,243666,760733,289054,959154,769691,665074,624500,493525,1035708,339420,1001678,105337,952274,268523,990947,2419,796652,828322,65475,782397,951557,998372,862969,841079,241782,309238,608573,510262,986635,923784,700426,614671,411932,1329,488444,1036284,656102,618281,521523) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406022 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406022 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000586s ]