SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 292648 LIMIT 1 [ RunTime:0.000866s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 292648 [ RunTime:0.003264s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (482760,184275,54534,467598,701510,66395,873521,485771,927742,102728,913552,949255,751183,840936,219312,953133,118548,18457,210122,172336,1031930,835602,881007,146225,724313,401727,413553,916517,576569,489691,116434,1022880,410951,790547,459198,4230,270197,727563,579169,513032,189332,939422,517523,814074,774493,909432,315542,726886,485212,46678,903802,658520,360408,344072,664841,48009,528583,894046,275799,82573) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 292648 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 292648 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000956s ]