SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101891 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101891 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (47158,576424,70215,484886,723633,351986,467024,647426,8218,673459,451818,118718,427665,773355,865248,960399,336673,470967,752345,755042,504085,1017836,477873,789937,537525,277421,415019,760270,125217,654909,651492,232761,240759,41413,494324,576453,1014690,444893,540677,940329,22818,531727,700463,229451,647312,919027,988214,654423,1042772,982780,845676,128268,411216,13301,607462,83381,654552,306714,579898,885114) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101891 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101891 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000440s ]