SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 796568 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 796568 [ RunTime:0.001867s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (282840,335352,1048190,984218,269424,625154,339064,581497,216592,4959,409590,568657,151182,503794,962402,158629,285273,474536,266484,1014812,18111,842125,373471,122211,949657,347743,342771,1047658,526233,940711,787017,430535,661849,947380,191497,922475,675534,736366,671886,874161,167799,823094,739793,148398,405575,1041336,616231,963921,696375,808086,914527,642104,916108,185056,38539,61062,926794,676030,932365,789545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 796568 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 796568 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]