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` = 40578 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40578 [ RunTime:0.001622s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420757,881329,299750,669056,918643,532372,571047,562226,414925,614746,215094,825407,666010,222601,511168,241270,424852,106542,903376,259264,491152,139017,794309,383624,1005120,297007,311772,799560,227461,381681,827044,402560,651596,67078,577831,765887,219866,382492,524697,940139,831822,952730,473391,581537,930797,553641,178874,93317,1048610,609390,951450,754844,605466,960541,374686,428468,554949,513485,384759,481440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000704s ]