SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 533952 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 533952 [ RunTime:0.001421s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (890017,110570,358964,963358,97929,756746,241946,337041,739256,79398,827250,1001097,94780,737751,251064,893808,592278,610427,644369,178312,544065,337791,821196,442461,613990,189313,170749,573142,634480,498209,746659,433493,508961,256738,135548,282901,361346,974515,522117,351630,745019,805932,165641,501448,459813,333092,38828,986486,985876,327432,775,858216,664469,945112,194684,273136,273723,65840,770443,357521) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 533952 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 533952 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]