SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 530812 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 530812 [ RunTime:0.001748s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (37921,53734,278616,929361,980564,772,1007203,84690,105252,764499,295072,577379,981012,914302,104978,536347,930952,1031827,595211,1028197,306572,503674,948743,177112,182630,936998,808791,101235,303033,515963,872008,63870,487728,851087,525079,727457,139476,806339,680990,467029,197372,168243,330843,715900,303604,295435,906963,919080,176746,869116,456347,414375,551117,53075,348968,931825,417380,175451,339067,279968) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 530812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 530812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]