SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042448 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042448 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (710314,977444,793480,1000159,214978,294096,153844,755569,106446,957444,763763,283540,470421,955908,288414,1043888,525393,671331,300554,557278,779533,329332,998982,527634,68965,654837,11619,1040151,733601,47347,250838,354413,446768,896195,769777,124341,90968,645890,130846,1044342,106403,820797,537498,430561,355560,711281,640931,742211,617117,510942,837650,167789,327730,84226,1026475,469994,877511,140531,595250,227002) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]