SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001590s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507582 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507582 [ RunTime:0.003934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75371,693105,90167,211418,666014,159073,810260,424398,299518,586283,664923,147776,43206,167202,506329,956252,571929,540490,990877,312187,1021463,382842,331290,1043168,1025562,937409,994897,438154,776535,263027,823737,676811,4693,863988,285609,536425,368937,718133,976274,1046593,1030526,586682,900471,967029,854879,840833,332435,1044284,909741,383886,170003,442373,209721,263765,123919,151677,807089,699816,181914,864349) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000715s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000486s ]